Appendix A: Pivot Grids
Calculated Fields Syntax
Add a Calculated Field to Pivot Grids in BrowserUX by selecting Show Field List from the toolbar, then Calculated Field. The following syntax gives users several options for customizing fields.
| Operator | Name | Syntax |
| + | addition | X + Y |
| - | subtraction | X - Y |
| * | multiplication | X * Y |
| / | division | X / Y |
| ^ | power | X^2 |
| < | Less than | X < Y |
| <= | less than or equal | X <= Y |
| > | greater than | X > Y |
| >= | greater than or equal | X >= Y |
| == | equal | X == Y |
| != | not equal | X != Y |
| | | OR | X | Y |
| & | AND | X & Y |
| ? | conditional | condition ? then : else |
| isNaN | function that checks if the value is not a number | isNaN(value) |
| !isNaN | function that checks if the value is a number | isNaN(value) |
| abs | function that returns the absolute value of a number | abs(number) |
| min | function that returns the minimum value | min(number1, number2) |
| max | function that returns the maximum value | max(number1, number2) |
Keyboard Navigation in Pivot Grids
| Focus | |
| Alt + J | Focuses the Pivot Table component. |
| PivotTable | |
| Tab | Moves the cell focus right side. If no cells are focused, it moves to the next active element in the browser page. |
| Shift + Tab | Moves the cell focus left side. If no cells are focused, it moves to the previous active element in the browser page. |
| Down arrow | Moves the cell focus downwards. |
| Up arrow | Moves the cell focus upwards. |
| Left arrow | Moves the cell focus left side. |
| Right arrow | Moves the cell focus right side. |
| Home | Goes to the first cell in the current row. |
| End | Goes to the last cell in the current row. |
| Ctrl + Home | Goes to the first cell in the table. |
| Ctrl + End | Goes to the last cell in the table. |
| Enter | If the current cell is an expand/collapse cell, it performs expand/collapse operation (drill operation). If the current row/column header is in value sort state, it performs value sorting. |
| Shift + Enter | If value sorting is enabled in the pivot table and the current cell is a header with respect to its value axis, it performs value sorting to either ascending or descending order. |
| Grouping Bar | |
| Tab | Moves to the next active element (field’s button) in the grouping bar. If no active elements present, it moves to the next active element in the browser page. |
| Shift + Tab | Moves to the previous active element (field’s button) in the grouping bar. If no active elements present, it moves to the previous active element in the browser page. |
| Shift + F | If the current active element is a field’s button and if it has a filter icon, the filter dialog will be opened to perform filtering. |
| Shift + S | If the current active element is a field’s button and if it has a sort icon, the sorting will be performed to the selected field. |
| Shift + E | If the current active element is a calculated field’s button and if it has an edit icon, the calculated field dialog will be opened to perform editing the selected calculated field. |
| Enter | Performs the selection operation of the current active element. If the current active element is a field’s button and it has a dropdown icon, the aggregation menu will open to perform calculations using aggregation options to the selected value field. |
| Delete | If the current active element is a field’s button, the selected field will be removed from the current report. |
| Down arrow | If the current active element is a dropdown list, the next item will be selected. |
| Up arrow | If the current active element is a dropdown list, the previous item will be selected. |
| Home | If the current active element is a dropdown list, the first item will be selected. |
| End | If the current active element is a dropdown list, the last item will be selected. |
| Alt + Down | If the current active element is a dropdown list, the popup will be opened. |
| Alt + Down | If the current active element is a dropdown list, the popup will be closed. |
| Esc or Escape | Closes the dropdown list. |
| Field List | |
| Ctrl + Shift + F | If the popup field list is enabled in either the pivot table or the pivot chart, the field list dialog will be opened. |
| Tab | Moves to the next active element in the field list. If no active elements present, it moves to the next active element in the browser page. |
| Shift + Tab | Moves to the previous active element in the field list. If no active elements present, it moves to the previous active element in the browser page. |
| Shift + F | If the current active element is a field’s button and if it has a filter icon, the filter dialog will be opened to perform filtering. |
| Shift + S | If the current active element is a field’s button and if it has a sort icon, the sorting will be performed to the selected field. |
| Shift + E | If the current active element is a calculated field’s button and if it has an edit icon, the calculated field dialog will be opened to perform editing the selected calculated field. |
| Enter | Performs the selection operation of the current active element. If the current active element is a field’s button and if it has a dropdown icon, the aggregation menu will be opened to perform calculations using aggregation options to the selected value field. |
| Delete | If the current active element is a field’s button, the selected field will be removed from the current report. |
| Down arrow | If the current active element is a tree node, it moves to the next node. |
| Up arrow | If the current active element is a tree node, it moves to the previous node. |
| Left arrow | If the current active element is a tree node, it collapses the current node. |
| Right arrow | If the current active element is a tree node, it expands the current node. |
| Home | If the current active element is a tree node, it goes to the first node. |
| End | If the current active element is a tree node, it goes to the last node. |
| Space | If the current active element is a tree node or a checkbox element, it will be either checked or unchecked. |
| Esc or Escape | Closes the popup field list dialog. |
| Toolbar | |
| Tab | Moves to the next active option in the toolbar. If no active elements present, it moves to the next active element in the browser page. |
| Shift + Tab | Moves to the previous active option in the toolbar. If no active elements present, it moves to the previous active element in the browser page. |
| Enter | Performs the selection operation of the current active element. |
| Calculated Field | |
| Shift + E | If the current active element is a field’s button and if it has an edit icon in either the field list or grouping bar UI, the calculated field dialog will be opened to perform editing the selected calculated field. |
| Tab | Moves to the next active element in the calculated field dialog. If no active elements present, it moves to the next active element in the browser page. |
| Shift + Tab | Moves to the previous active element in the calculated field dialog. If no active elements present, it moves to the previous active element in the browser page. |
| Enter | Performs the selection operation of the current active element. If the current active element is a tree node, it copies the selected field name/formula to the formula text area to perform calculations. |
| Down arrow | If the current active element is a tree node, it moves to the next node. |
| Up arrow | If the current active element is a tree node, it moves to the previous node. |
| Left arrow | If the current active element is a tree node, it collapses the current node. |
| Right arrow | If the current active element is a tree node, it expands the current node. If the current active element is a tree node and has a menu icon, the aggregation menu will be opened to select appropriate aggregation type to the selected field. |
| Home | If the current active element is a tree node, it goes to the first node. |
| End | If the current active element is a tree node, it goes to the last node. |
| Esc or Escape | Closes the filter dialog. |
| Drill Through | |
| Tab | Moves to the next active element in the drill-through dialog. If the current active element is a Grid cell, it moves the cell focus to right side. If no active elements present, then it moves to the next active element in the browser page. |
| Shift + Tab | Moves to the previous active element in the drill-through dialog. If the current active element is a Grid cell, it moves the cell focus to left side, If no active elements present, then it moves to the previous active element in the browser page. |
| Down arrow | Moves the row/cell focus downwards. |
| Up arrow | Moves the row/cell focus upwards. |
| Left arrow | Moves the cell focus left side. |
| Right arrow | Moves the cell focus left side. |
| Home | Goes to the first cell in the current row. |
| End | Goes to the last cell in the current row. |
| Ctrl + Home | Goes to the first cell in the table. |
| Ctrl + End | Goes to the first cell in the table. |
| Enter | Performs the selection operation of the current active element. |
| Esc or Escape | If the cell is in selected state, it deselects all rows/cells. If the row/cell is in edit state, it cancels the current entries in the row/cell. If the current active element is not a row/cell, it closes the drill-through dialog. |
| F2 | If the cell is in selected state, it deselects all rows/cells. If the row/cell is in edit state, it cancels the current entries in the row/cell. If the current active element is not a row/cell, it closes the drill-through dialog. |
| Insert | Adds a new row/cell in the data grid. |
| Delete | Removes the selected row in the data grid. |
| Filter Dialog | |
| Shift + F | If the current active element is a field’s button and if it has a filter icon in either the field list or grouping bar UI, the filter dialog will be opened to perform filtering. |
| Tab | If the current active element is a field’s button and if it has a filter icon in either the field list or grouping bar UI, the filter dialog will be opened to perform filtering. |
| Shift + Tab | Moves to the next active element in the filter dialog. If no active elements present, it moves to the next active element in the browser page. |
| Enter | Moves to the previous active element in the filter dialog. If no active elements present, it moves to the previous active element in the browser page. |
| Down arrow | If the current active element is a tree node, it moves to the next node. |
| Up arrow | If the current active element is a tree node, it moves to the previous node. |
| Left arrow | If the current active element is a tree node, it collapses the current node. If the current active element is a tab, it moves focus to the previous tab element. |
| Right arrow | If the current active element is a tree node, it expands the current node. If the current active element is a tab, it moves focus to the next tab element. |
| Home | If the current active element is a tree node, it goes to the first node. |
| End | If the current active element is a tree node, it goes to the last node. |
| Space | If the current active element is a tree node or a checkbox element, it will be either checked or unchecked. |
| Esc or Escape | Closes the filter dialog. |
| Alt + Down | If the current active element is a DropDownList or DatePicker or DateTimePicker, the popup will be opened. |
| Alt + Up | If the current active element is a DropDownList or DatePicker or DateTimePicker, the popup will be closed. |
Chart Types in Pivot Grids
These are the available chart types within Pivot Grids.
| Column, Stacked Column, 100% Stacked Column | Bubble |
|
Bar, Stacked Bar, 100% Stacked Bar |
Pareto |
|
Line, Stacked Line, Step Line, 100% Stacked Line |
Radar |
| Area, Stacked Area, Step Area, 100% Stacked Area | Pie |
| Scatter | Doughnut |
| Polar | Funnel |
| Spline | Pyramid |